<% 'Option Explicit Response.Buffer = TRUE Dim conn, rs, strSQL ' DatabaseConnection variables Dim TheString ' SQLRemoveBadCharactersInc SetVars Function Dim adjustingtext ' SQLRemoveBadCharactersInc RemoveCharacters Function Dim arysplit, i, j, strOutput ' SQLRemoveBadCharactersInc stripHTML2 Function Dim strSuppliedPID ' Profile ID stored in Querystring Dim strUsername, strTitle, strGreeting, strFirstName, strLastName Dim strEmailAddress, strActive, strLastActive, strProfilePrivacy Dim strIdentityPrivacy, strEmailPrivacy, strDescription, strGender Dim strOccupation, strSpokenLanguages, strLocation, strTimezone Dim strURL1, strURLDescription1, strURL2, strURLDescription2 Dim strURL3, strURLDescription3, strPhotoLocation, strPhotoApproval Dim strPhotoWidth, strPhotoHeight Dim strNumericCheck Dim strProfilePicturesURL strProfilePicturesURL = "http://www.groupintervisual.net/Assets_ProfilePictures/" %> <% 'Extract ProfileID from Querystring strSuppliedPID = left(stripHTML2(RemoveCharacters(trim(request.querystring("pid")))),10) If Session("GivCustomerID") = "" Or Session("UserID") = "" Then 'not logged in strBouncebackURL = "/asp/homepage.asp?error=NotLoggedIn&referral=www.online-supervision.net/asp/profile.asp?PID=" & strSuppliedPID response.redirect strBouncebackURL End If IF Session("Authorised") <> "yes" AND Session("Authorised") <> "pending" AND Session("UserID") + 1 <> strSuppliedPID + 1 Then 'not authorised and not own profile strBouncebackURL = "/asp/homepage.asp?error=NotLoggedIn&referral=www.online-supervision.net/asp/profile.asp?PID=" & strSuppliedPID response.redirect strBouncebackURL End If ' Check if Querystring is numerical i.e has ' not been tampered with & will work on db. If NOT IsNumeric (strSuppliedPID) Then strSuppliedPID = "0" ' this converts alphabetical PID's, which may have ' been tampered with, to a bad userID which will call up ' an error message asking for a proper URL, rather than ' a page not found message, which results from trying to ' find alphabetical data in the UserID field on the db strNumericCheck = "No" End If If strNumericCheck <> "No" Then If strSuppliedPID < 1 OR strSuppliedPID > 10000 Then strNumericCheck = "No" End If End If If strNumericCheck = "No" Then ' No querystring or querystring with wrong value strProfile = "ProfileNotFound" End If %> www.online-supervision.net
<% If Session("UserID") = "" Then %>click here to login to the secure area of the site<% Else response.write "" End If %> homepage
<% If Session("UserID") = "" Then %> register to provide or receive online clinical supervision<% Else response.write "" End If %> online-supervision.net bulletin boards online supervision research resources & links contact

<% If strProfile <> "ProfileNotFound" Then %> <% Set conn = Server.CreateObject("ADODB.Connection") conn.Open connstr ' Open database connection strSQL = "SELECT UserID, GivCustomerID, UserStatus, WorkType, " strSQL = strSQL & "Orientation, Profession, PracticeExpYears, " strSQL = strSQL & "Individual, MinSize, MaxSize, UseList, " strSQL = strSQL & "UseArchives, UseIM, UseFileStorage, " strSQL = strSQL & "UseVideoconferencing, InternetExpYears, " strSQL = strSQL & "Structure, TimeCommittment, Payment, " strSQL = strSQL & "Leadership, Research, Hear, Comments, " strSQL = strSQL & "TimeDateSubmitted, Authorised, HighestQual, " strSQL = strSQL & "QualName, QualInstitution, InstitutionCountry, " strSQL = strSQL & "FurtherProfQuals, SupervisionExprnceTraining, " strSQL = strSQL & "ProfExpernceExpertse, PresentJobTitle, " strSQL = strSQL & "WorkAddress, WorkPhoneNo, WorkPhoneCountryCode, " strSQL = strSQL & "WorkPhoneAreaCode, ProfRegNo, ProfRegBody, " strSQL = strSQL & "ProfRegBodyAddress, OwnSupervisorName, " strSQL = strSQL & "OwnSupervisorContactDetails, AdditionalDetails, " strSQL = strSQL & "FurtherInfoDate, InsuranceDetails" strSQL = strSQL & " FROM RegisterInterest" strSQL = strSQL & " WHERE UserID = '" & strSuppliedPID & "'" Set rs = conn.Execute(strSQL) If Not rs.EOF Then strTimeDateSubmitted = rs.Fields("TimeDateSubmitted") strAuthorised = rs.Fields("Authorised") strGivCustomerID = rs.Fields("GivCustomerID") strUserID = rs.Fields("UserID") strUserStatus = rs.Fields ("UserStatus") strWorkType = rs.Fields ("WorkType") strOrientation = rs.Fields ("Orientation") strProfession = rs.Fields ("Profession") strPracticeExpYears = rs.Fields ("PracticeExpYears") strIndividual = rs.Fields ("Individual") strMinSize = rs.Fields ("MinSize") strMaxSize = rs.Fields ("MaxSize") strUseList = rs.Fields ("UseList") strUseArchives = rs.Fields ("UseArchives") strUseIM = rs.Fields ("UseIM") strUseFileStorage = rs.Fields ("UseFileStorage") strUseVideoconferencing = rs.Fields ("UseVideoconferencing") strInternetExpYears = rs.Fields ("InternetExpYears") strStructure = rs.Fields ("Structure") strTimeCommittment = rs.Fields ("TimeCommittment") strPayment = rs.Fields ("Payment") strLeadership = rs.Fields ("Leadership") strResearch = rs.Fields ("Research") strHear = rs.Fields("Hear") strComments = rs.Fields("Comments") strHighestQual = rs.Fields("HighestQual") strQualName = rs.Fields("QualName") strQualInstitution = rs.Fields("QualInstitution") strInstitutionCountry = rs.Fields("InstitutionCountry") strFurtherProfQuals = rs.Fields("FurtherProfQuals") strSupervisionExprnceTraining = rs.Fields("SupervisionExprnceTraining") strProfExpernceExpertse = rs.Fields("ProfExpernceExpertse") strPresentJobTitle = rs.Fields("PresentJobTitle") strWorkAddress = rs.Fields("WorkAddress") strWorkPhoneNo = rs.Fields("WorkPhoneNo") strWorkPhoneCountry = rs.Fields("WorkPhoneCountryCode") strWorkPhoneAreaCode = rs.Fields("WorkPhoneAreaCode") strProfRegNo = rs.Fields("ProfRegNo") strProfRegBody = rs.Fields("ProfRegBody") strProfRegBodyAddress = rs.Fields("ProfRegBodyAddress") strOwnSupervisorName = rs.Fields("OwnSupervisorName") strOwnSupervisorContactDetails = rs.Fields("OwnSupervisorContactDetails") strAdditionalDetails = rs.Fields("AdditionalDetails") strFurtherInfoDate = rs.Fields("FurtherInfoDate") strInsuranceDetails = rs.Fields("InsuranceDetails") rs.Close ' Close recordset Set rs = nothing ' Remove recordset If strResearch <> "not willing to participate........" Then strSQL = "SELECT Username, Title, Greeting, FirstName, LastName, EmailAddress," strSQL = strSQL & " Active, LastActive, ProfilePrivacy, IdentityPrivacy, EmailPrivacy," strSQL = strSQL & " Description, Gender, Occupation, SpokenLanguages, Location, Timezone," strSQL = strSQL & " URL1, URLDescription1, URL2, URLDescription2, URL3, URLDescription3," strSQL = strSQL & " PhotoLocation, PhotoApproval, PhotoWidth, PhotoHeight," strSQL = strSQL & " StreetAddress1, StreetAddress2, Town, County, Country, PostCode," strSQL = strSQL & " TelephoneNo, EmailAddress" strSQL = strSQL & " FROM Customers" strSQL = strSQL & " WHERE CustomerID = '" & strGivCustomerID & "'" Set rs = conn.Execute(strSQL) If Not rs.EOF Then ' No db record found for supplied UserID strAddress1 = rs.Fields("StreetAddress1") strAddress2 = rs.Fields("StreetAddress2") strTown = rs.Fields("Town") strCounty = rs.Fields("County") strCountry = rs.Fields("Country") strPostcode = rs.Fields("PostCode") strTelephone = rs.Fields("TelephoneNo") strEmail = rs.Fields("EmailAddress") strUsername = LCase(rs.Fields ("Username")) strTitle = rs.Fields ("Title") strGreeting = rs.Fields ("Greeting") strFirstName = rs.Fields ("FirstName") strLastName = rs.Fields ("LastName") strEmailAddress = rs.Fields ("EmailAddress") strActive = rs.Fields ("Active") strLastActive = rs.Fields ("LastActive") strProfilePrivacy = rs.Fields ("ProfilePrivacy") strIdentityPrivacy = rs.Fields ("IdentityPrivacy") strEmailPrivacy = rs.Fields ("EmailPrivacy") strDescription = rs.Fields ("Description") strGender = rs.Fields ("Gender") strOccupation = rs.Fields ("Occupation") strSpokenLanguages = rs.Fields ("SpokenLanguages") strLocation = rs.Fields ("Location") strTimezone = rs.Fields ("Timezone") strURL1 = rs.Fields ("URL1") strURLDescription1 = rs.Fields ("URLDescription1") strURL2 = rs.Fields ("URL2") strURLDescription2 = rs.Fields ("URLDescription2") strURL3 = rs.Fields ("URL3") strURLDescription3 = rs.Fields ("URLDescription3") strPhotoLocation = rs.Fields ("PhotoLocation") strPhotoApproval = rs.Fields ("PhotoApproval") strPhotoWidth = rs.Fields ("PhotoWidth") strPhotoHeight = rs.Fields ("PhotoHeight") Set rs = nothing ' Close recordset %>

<% If strAuthorised <> "No" OR Session("UserStatus") = "researching" Then %>
<% If cstr(Session("UserID")) = cstr(strSuppliedPID) Then %> <% Else If cstr(Session("UserStatus")) = cstr("researching") Then %> <% Else %> <% End If End If %>

<% response.write strFirstName%> <% response.write strLastName%>

<% If Session("UserID") + 1 = strSuppliedPID + 1 Then response.write "

Welcome, " & Session("Title") & " " & Session("Firstname") & " " & Session("Lastname") & "!" response.write "

Click on the buttons above to edit your profile or return to your homepage!

" Else If Session("UserStatus") = "researching" Then response.write "

Welcome, " & Session("Title") & " " & Session("Firstname") & " " & Session("Lastname") & "!" response.write "

In your capacity as researcher, you may click on the buttons above to grant, deny or enter into dialogue about this registrant's authorisation to access supervision on the site and participate in the research. Or you can confirm that this user's credentialling documentation has been received, return to the search page, listing those registrants who have submitted further professional details and whose authorisation is pending, or return to your homepage.

" End If End If %>
<% If strIdentityPrivacy = "Public" AND strPhotoLocation <> "NA" AND strPhotoApproval = "Yes" Then ' Live Photo %>Member picture <% Else %> Member picture <% End If %>
<% If strUserStatus <> "researching" Then %>

Essential Personal/Professional Details

<% response.write strTitle & " "%><% response.write strFirstName & " "%><% response.write strLastName%> has registered interest with online-supervision.net in <% response.write strUserStatus%> supervision mainly for <% response.write strWorkType%> work.

<% response.write strFirstName%> works predominantly in the field of <% response.write strProfession%> <% Set conn = Server.CreateObject("ADODB.Connection") conn.Open connstr ' Open database connection strSQL = "SELECT ProfessionID" strSQL = strSQL & " FROM UsersProfessions" strSQL = strSQL & " WHERE UserID = '" & strSuppliedPID & "'" Set rs = conn.Execute(strSQL) If Not rs.eof Then response.write ", and is interested in " & strUserStatus & " supervision for the practice of:

    " do while not rs.eof strProfessionID = rs.Fields("ProfessionID") strSQL = "SELECT ProfessionName" strSQL = strSQL & " FROM Professions" strSQL = strSQL & " WHERE ProfessionID = '" & strProfessionID & "'" Set rs2 = conn.Execute(strSQL) strProfessionName = rs2.Fields("ProfessionName") rs2.Close ' Close recordset Set rs2 = nothing ' Remove recordset response.write "
  • " & strProfessionName & "
  • " rs.movenext loop rs.Close ' Close recordset Set rs = nothing ' Remove recordset response.write "
" Else response.write "." End If %>

The primary therapeutic orientation in <% response.write strFirstName%>'s work is <% response.write strOrientation strSQL = "SELECT OrientationID" strSQL = strSQL & " FROM UserOrientations" strSQL = strSQL & " WHERE UserID = '" & strSuppliedPID & "'" Set rs = conn.Execute(strSQL) If Not rs.eof Then response.write ". " & strFirstName & " is ready to " & replace(strUserStatus,"ing","e") & " supervision with a theoretical focus as follows:

    " do while not rs.eof strOrientationID = rs.Fields("OrientationID") strSQL = "SELECT OrientationName" strSQL = strSQL & " FROM Orientations" strSQL = strSQL & " WHERE OrientationID = '" & strOrientationID & "'" Set rs2 = conn.Execute(strSQL) strOrientationName = rs2.Fields("OrientationName") rs2.Close ' Close recordset Set rs2 = nothing ' Remove recordset response.write "
  • " & strOrientationName & "
  • " rs.movenext loop rs.Close ' Close recordset Set rs = nothing ' Remove recordset response.write "
" Else response.write "." End If %>

<% response.write strFirstName%> has been practicing for <% response.write strPracticeExpYears%> years, with <% response.write strInternetExpYears%> years experience of Internet use.



Preferred Supervision Arrangements

The minimum size <% response.write strFirstName%> would want a supervision group to be is <% response.write strMinSize%>  members, with <% response.write strMaxSize%> as the maximum number. <% If strIndividual <> "" Then %> Asked if it was ideally individual rather than group supervision <% response.write strFirstName%> was looking for, the answer was <% response.write strIndividual%>. <% End If %> Facilitites and tools <% response.write strFirstName%> would want to use include:

    <% If strUseList <> "" Then response.write "
  • " & strUseList End If If strUseArchives <> "" Then response.write "
  • " & strUseArchives End If If strUseIM <> "" Then response.write "
  • " & strUseIM End If If strUseFileStorage <> "" Then response.write "
  • " & strUseFileStorage End If If strUseVideoconferencing <> "" Then response.write "
  • " & strUseVideoconferencing End If %>

The sort of supervision structure <% response.write strFirstName%> is looking for is <% response.write strStructure%> <% response.write strFirstName%> is personally ready to make a time commitment in the region of <% response.write strTimeCommittment%> hours per week. <% If strUserStatus = "providing" Then response.write strFirstName & " is " & strPayment End If %> <% If strUserStatus = "receiving" Then %>In terms of leadership, <% response.write strFirstName%> prefers the idea of <% response.write strLeadership End If %>



<% End If %>

Detailed Professional Information

<% response.write strFirstName%> has undertaken a professional training in <% If strQualName <> "" Then Response.write strQualName Else response.write " awaiting name of qualification " End If %> at <% If strHighestQual <> "" Then Response.write strHighestQual Else response.write " awaiting level of qualification " End If %> level at <% If strQualInstitution <> "" Then Response.write strQualInstitution Else response.write " awaiting name of institution " End If %>, <% If strInstitutionCountry <> "" Then Response.write strInstitutionCountry Else response.write " awaiting country of institution" End If %> .

Further professional experience and expertise <%=strFirstname%> has acquired includes the following:

<% If strFurtherProfQuals <> "" Then response.write strFurtherProfQuals & "

" Else response.write "No other qualifications supplied.
" End If If strProfExpernceExpertse <> "" Then response.write "

" & strProfExpernceExpertse & "

" Else response.write "No details of further experience or expertise supplied.
" End If If strUserStatus = "providing" Then response.write "

" & strSupervisionExprnceTraining & "

" End If %>

Professional registration details follow:
Registration no.: <% If strProfRegNo <> "" Then Response.write strProfRegNo Else response.write " awaiting professional registration details" End If %>
Registration body: <% If strProfRegBody <> "" Then Response.write strProfRegBody Else response.write " awaiting professional registration body details" End If %>
Registration body Address: <% If strProfRegBodyAddress <> "" Then Response.write strProfRegBodyAddress Else response.write " awaiting professional registration body address details" End If %>

Present Job Title: <% If strPresentJobTitle <> "" Then Response.write strPresentJobTitle Else response.write " awaiting curerent job title details" End If %> <% If strAdditionalDetails <> "" Then Response.write "

Additional Details:
" & strAdditionalDetails End If %>

<% If Session("UserID") = strSuppliedPID OR Session("UserStatus") = "researching" Then %>

The following information is only on display to the person whose profile this is, or if person viewing the profile is a member of the research team...

Insurance Details: <%= strInsuranceDetails%>
Work Address: <%= strWorkAddress%>
Work Phone Number: <%= strWorkPhoneCountry%> <%= strWorkPhoneAreaCode%> <%= strWorkPhoneNo%>
Own Supervisor's Name: <%= strOwnSupervisorName%>
Own Supervisor's Contact Details: <%= strOwnSupervisorContactDetails%>
Date Further Professional Information was Submitted: <%= strFurtherInfoDate%>

 

<% End If response.write "

Links " & strFirstName & " " & strLastName & " invites you to view:
" If strURL1 <> "NA" AND strURLDescription1 <> "NA" Then If LCase(left (strURL1,7)) = "http://" Then Response.Write "" & strURLDescription1 & "
" Else Response.Write "" & strURLDescription1 & "
" End If End If If strURL2 <> "NA" AND strURLDescription2 <> "NA" Then If LCase(left (strURL2,7)) = "http://" Then Response.Write "" & strURLDescription2 & "
" Else Response.Write "" & strURLDescription2 & "
" End If End If If strURL3 <> "NA" AND strURLDescription3 <> "NA" Then If LCase(left (strURL3,7)) = "http://" Then Response.Write "" & strURLDescription3 & "
" Else Response.Write "" & strURLDescription3 & "" End If End If Response.write "
" %>

 

<% Else %>



Sorry, <%=Session("Firstname")%>, but <%=strTitle & " " & strFirstname & " " & strLastname%>'s application to join the research project into online supervision and use the online supervision services available here has not yet been authorised.

Please click above either on the homepage link, or click on your browser's 'BACK' button, to return to your search to refine it, if you want to try looking for other profiles.

<% End If Else %>



 

Sorry, <%=Session("Firstname")%> , but the profile corresponding to the profile ID number entered (PID#<%=strSuppliedPID%>) can not be found.

Please click above either on the homepage link, or click on your browser's 'BACK' button, to return to your search to refine it, if you want to try looking for other profiles.

<% End If Else response.write "

Sorry! Although you have entered a valid URL for someone " response.write "who has registered on the online-supervision.net database, we are " response.write "currently only able to broker supervision services for registrants who " response.write "are willing to participate in the research project associated with." response.write "these services. We will now e-mail the registrant in question and " response.write "encourage them to be part of the research project. If we are " response.write "successful we will contact you " response.write "to let you know you can now access the profile in question." ' send e-mail to Ben End If Else %>



 

Sorry, <%=Session("Firstname")%> , but the profile corresponding to the profile ID number entered (PID#<%=strSuppliedPID%>) can not be found.

Please click above either on the homepage link, or click on your browser's 'BACK' button, to return to your search to refine it, if you want to try looking for other profiles.

<% End If Else %>



 

Sorry, <%=Session("Firstname")%> , but profiles can only be located with a valid profile ID number (PID#<%=strSuppliedPID%>) in the URL entered above.

Please click above either on the homepage link, or click on your browser's 'BACK' button, to return to your search to refine it, if you want to try looking for other profiles.

<% End If ' end PID test %>


Copyright 2002-4, GroupInterVisual Ltd. All rights reserved.